﻿CREATE TABLE [dbo].[Branches] (
    [BranchId]      UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [Name]          NVARCHAR (50)    NOT NULL,
    [GroupBranchId] UNIQUEIDENTIFIER NOT NULL,
    [CityId]        UNIQUEIDENTIFIER NOT NULL,
    [Street]        NVARCHAR (50)    NOT NULL,
    [Number]        INT              NULL,
    [ZipCode]       NVARCHAR (50)    NULL,
    [BranchFlagId]  UNIQUEIDENTIFIER NOT NULL,
    [BranchTypeId]  UNIQUEIDENTIFIER NOT NULL,
    [PhoneNumber1]  NVARCHAR (50)    NULL,
    [PhoneNumber2]  NVARCHAR (50)    NULL,
    [FaxNumber]     NVARCHAR (50)    NULL,
    [InsertDate]    DATETIME         NULL,
    [UpdateDate]    DATETIME         NULL,
    [Email]         NVARCHAR (200)   NULL
);



